<?php include_once('header.php'); ?>
<?php include_once('left_navigation.php'); ?>
<?php
	include('../classess/class_affiliate_user.php');

	$new_user = new affUser();

	if(isset($_GET['del_id'])){
		$delete_activate_user = $new_user->del_user($_GET['del_id']); 
	}

	if(isset($_GET['act_id'])){
		$delete_activate_user = $new_user->activate_user($_GET['act_id']); 
	}

?>
<div class="col-lg-12"><!-- Start Middle Content Div-->
	<div class="box">
		<div class="row">		
			<div class="col-lg-12">
				<div class="box">
					<div class="box-header" data-original-title>
						<h2><i class="fa fa-user"></i><span class="break"></span>Affiliate Users</h2>
						<div class="box-icon">
							<a href="table.html#" class="btn-minimize"><i class="fa fa-chevron-up"></i></a>
							<a href="table.html#" class="btn-close"><i class="fa fa-times"></i></a>
						</div>
					</div>
					<div class="box-content">
						<?php 
								if(isset($delete_activate_user)){	
							?>
							<div class="alert alert-info">
								<div style="float: right; width: 5%;"><button type="button" class="close" data-dismiss="alert">&times;</button></div>
								<div style="float:left;width: 92%;word-wrap: break-word;"><?php echo $delete_activate_user; ?></div>
								<div style="clear:both;"></div>							
							</div>
							<?php
								}
							?>
						<div class="search_box">
							<div class="fl_left sel_label_search">Search:</div>
							<div class="fl_left" style="width:60%;">									
								<form method="POST" action="<?php echo $_SERVER['PHP_SELF'].'?aff_prg=1'; ?>" id="search_form" name="search_form">
									<input type="text" name="search_value" id="search_value" placeholder="Search" value="<?php if(isset($_POST['search_value'])){echo $_POST['search_value']; }else{ echo '';}  if(isset($_GET['srch_value'])){echo $_GET['srch_value']; }else{ echo '';}?>">&nbsp;
									<input type="submit" name="submit_search" id="submit_search" class="btn btn-blue srch_btn" value="Search">
								</form>

							</div>
							<div class="clear_fix"></div>
						</div>
						<table class="table table-striped table-bordered">
						  <thead>
							  <tr>
								  <th>User Name</th>
								  <th>Email</th>
								  <th>Phone</th>
								  <th>City</th>
								  <th>Country</th>
								  <th>Web URL</th>
								  <th>Is Active</th>
							  </tr>
						  </thead>   
						  <tbody>
							<?php
								$rec_limit = 15;

								$condition_search = '';
								$value = '';
								if(isset($_POST['search_value'])){										
									$value = trim($_POST['search_value']);
									
									if(!empty($value)){
										$cond_where = 'WHERE ';
										$condition_search = $cond_where." (username like '%".$value."%' OR email_id like '%".$value."%' OR phone like '%".$value."%' OR city like '%".$value."%' OR country like '%".$value."%')";
									}
								}

								if(isset($_GET['srch_value'])){	
									$value = $_GET['srch_value'];
									
									if(!empty($value)){
										$cond_where = 'WHERE ';

										$condition_search = $cond_where." (username like '%".$value."%' OR email_id like '%".$value."%' OR phone like '%".$value."%' OR city like '%".$value."%' OR country like '%".$value."%')";
									}
								}

								$select_count_course = "SELECT count(*) FROM tbl_affiliate ".$condition_search;
								$result_count_course = mysql_query($select_count_course);

								$row = mysql_fetch_array($result_count_course);
								$rec_count = $row[0];

								if( isset($_GET['page']) )
								{
								   $page = $_GET['page'] + 1;
								   $offset = $rec_limit * $page ;
								}
								else
								{
								   $page = 0;
								   $offset = 0;
								}

								$serial_number = $page*$rec_limit;
								
								$left_rec = $rec_count - ($page * $rec_limit);

								$select_trainer = "SELECT * FROM tbl_affiliate ".$condition_search." ORDER BY id DESC LIMIT ".$offset.", ".$rec_limit;
								$query_trainer = mysql_query($select_trainer) or die(mysql_error());
								
								$i = 1;
								if(mysql_num_rows($query_trainer)>0){
									while($row = mysql_fetch_array($query_trainer)){
										$serial_number++;
										echo '
											<tr>
												<td>'.$row['username'].'</td>
												<td>'.$row['email_id'].'</td>
												<td>'.$row['phone'].'</td>
												<td>'.$row['city'].'</td>
												<td>'.$row['country'].'</td>
												<td>'.$row['website_url'].'</td>
												<td>';
													if($row['is_active']){
														echo '<a class="" href="'.$_SERVER['PHP_SELF'].'?aff_prg=1&del_id='.$row['id'].'" title="Delete" style="text-decoration:none;"><span class="label label-success">Active</span></a>';
													}else{
														echo '<a class="" href="'.$_SERVER['PHP_SELF'].'?aff_prg=1&act_id='.$row['id'].'" title="Activate" style="text-decoration:none;"><span class="label label-default">Inactive</span></a>';
													}
												echo '</td>
											</tr>
										';
										$i++;
									}
								}else{
									echo '<tr>
										<td colspan="9" style="text-align:center;">No Records Found</td>
									</tr>';
								}

							?>						
						  </tbody>
					  </table>  
					  <?php		
						echo '<ul class="pagination">';
						if($rec_count>$rec_limit){
							if( $page > 0 && $left_rec > $rec_limit)
							{
							   $last = $page - 2;
							   echo '<li><a href="'.$_SERVER["PHP_SELF"].'?aff_prg=1&page='.$last.'&srch_value='.$value.'" class="anc_click">Prev</a></li> ';
							   echo '<li><a href="'.$_SERVER["PHP_SELF"].'?aff_prg=1&page='.$page.'&srch_value='.$value.'" class="anc_click">Next</a></li>';
							}
							else if( $page == 0 )
							{
							   echo '<li><a href="'.$_SERVER["PHP_SELF"].'?aff_prg=1&page='.$page.'&srch_value='.$value.'" class="anc_click">Next</a></li>';
							}
							else if( $left_rec < $rec_limit || $left_rec == $rec_limit )
							{
							   $last = $page - 2;
							   echo '<li><a href="'.$_SERVER["PHP_SELF"].'?aff_prg=1&page='.$last.'&srch_value='.$value.'" class="anc_click">Prev</a></li>';
							}
						}
						echo '</ul>';
						?>
					</div>
				</div>
			</div><!--/col-->

		</div><!--/row-->

		
	</div><!-- End Box Div-->
</div><!-- End Middle Content Div-->
<?php include_once('footer.php'); ?>
<script>
	$ = jQuery.noConflict();
	$(document).ready(function(){	
		$('.close').click(function(){
			$('.alert-info').addClass('hide');
		});

		$('#add_user').click(function(){
			document.add_course_form.submit();
		});

		$('#submit_course_search').click(function(){
			document.search_course_form.submit()
		});
	});
		
	
</script>